[dbo].[AsiNrdsMemberDesignation]

Property	Value
Created	3:53:48 PM Tuesday, November 22, 2011
Last Modified	11:40:00 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)	Default
ID	varchar(10)	10	('')
Abr	bit	1	((0))
AbrDate	datetime	8
Abrm	bit	1	((0))
AbrmDate	datetime	8
Alc	bit	1	((0))
AlcDate	datetime	8
Arm	bit	1	((0))
ArmDate	datetime	8
Ccim	bit	1	((0))
CcimDate	datetime	8
Cips	bit	1	((0))
CipsDate	datetime	8
Cpm	bit	1	((0))
CpmDate	datetime	8
Crb	bit	1	((0))
CrbDate	datetime	8
Cre	bit	1	((0))
CreDate	datetime	8
Crs	bit	1	((0))
CrsDate	datetime	8
Gaa	bit	1	((0))
GaaDate	datetime	8
Gri	bit	1	((0))
GriDate	datetime	8
Ltg	bit	1	((0))
LtgDate	datetime	8
Raa	bit	1	((0))
RaaDate	datetime	8
Rce	bit	1	((0))
RceDate	datetime	8
Sior	bit	1	((0))
SiorDate	datetime	8
NARTimestamp	varchar(20)	20	('')
TIME_STAMP	timestamp	8

	Name	Columns	Unique
	PK_AsiNrdsMemberDesignation	ID

SQL Script

CREATE TABLE [dbo].[AsiNrdsMemberDesignation]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Permission] DEFAULT (''),
[Abr] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Abr] DEFAULT ((0)),
[AbrDate] [datetime] NULL,
[Abrm] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Abrm] DEFAULT ((0)),
[AbrmDate] [datetime] NULL,
[Alc] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Alc] DEFAULT ((0)),
[AlcDate] [datetime] NULL,
[Arm] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Arm] DEFAULT ((0)),
[ArmDate] [datetime] NULL,
[Ccim] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Ccim] DEFAULT ((0)),
[CcimDate] [datetime] NULL,
[Cips] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Cips] DEFAULT ((0)),
[CipsDate] [datetime] NULL,
[Cpm] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Cpm] DEFAULT ((0)),
[CpmDate] [datetime] NULL,
[Crb] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Crb] DEFAULT ((0)),
[CrbDate] [datetime] NULL,
[Cre] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Cre] DEFAULT ((0)),
[CreDate] [datetime] NULL,
[Crs] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Crs] DEFAULT ((0)),
[CrsDate] [datetime] NULL,
[Gaa] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Gaa] DEFAULT ((0)),
[GaaDate] [datetime] NULL,
[Gri] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Gri] DEFAULT ((0)),
[GriDate] [datetime] NULL,
[Ltg] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Ltg] DEFAULT ((0)),
[LtgDate] [datetime] NULL,
[Raa] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Raa] DEFAULT ((0)),
[RaaDate] [datetime] NULL,
[Rce] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Rce] DEFAULT ((0)),
[RceDate] [datetime] NULL,
[Sior] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_Sior] DEFAULT ((0)),
[SiorDate] [datetime] NULL,
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDesignation_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsMemberDesignation] ADD CONSTRAINT [PK_AsiNrdsMemberDesignation] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO